More about the Criteria, Sort and Display Tabs
Criteria Tab
The Criteria tab is used to enter values to select records from the database.
Highlight the field in the Selected Fields window, for which you would like to specify criteria.
The Prompt Value When Running checkbox is used to control the entry of parameters when the report is run. If checked, the Extract will prompt for a selection value to be entered for the field when the extract is run.
The Operator provides the choice of the criteria which may be applied to the selected field (is greater than; is not; etc. The criteria offered will vary depending on whether the field is alphabetic, numeric or a date.
The Value is the value to be used with the Operator to perform the selection.
Dependent on the Operator selected (Single, Multiple, Between), the window display will change to allow for the entry of required value/s.
Single Value Operators - imply the use of a single value (i.e. Is Exactly, Is Not, Starts With etc.,)
- Select the Operator, enter the Value and press the Tab key.
- The criteria selection for the highlighted field will be displayed at the foot of the Criteria tab window.
- The New button may be used to add another Value to the same field (using the and / or buttons) or to add another Value to a new field
- The Delete button may be used to remove previously selected Operators and Values from the criteria selection.
Multiple Value Operators - imply the use of multiple values (i.e. One of, Not one of)
- Select the Operator, enter the Value, and then press the Tab key.
- The criteria selection for the highlighted field will be displayed at the foot of the Criteria tab window and the window display will alter:
- The Plus and Minus buttons are used to add and remove values in the selection window.
- The New button may be used to add another Value to the same field (using the and / or buttons) or to add another Value to a new field
- The Delete button may be used to remove previously selected Operators and Values from the criteria selection.
- The And/Or radio buttons are used to set the condition that Extractor will use with the multiple value. The default is 'Or'.
Between Value Operators - imply the use of 'between' values (i.e. Between, Not Between)
- Select the Operator, enter the Value, and then press the Tab key.
- The criteria selection for the highlighted field will be displayed at the foot of the Criteria tab window and the window display will alter:
- The New button may be used to add another Value to the same field (using the and / or buttons) or to add another Value to a new field
- The Delete button is used to remove previously selected Operators and Values from the criteria selection.
- The And/Or radio buttons are used to set the condition that Extractor will use with the multiple values. The default is 'Or'.
Special Value
The Special Value option allows users to compare against values that are calculated at runtime.
Sort Tab
The Sort tab is used to enter parameters to control the sorting of data.
The Sort Sequence displays the level of the sort, '1' being the highest. The level will be displayed on the Selected Fields window.
The Ascending and Descending radio buttons are used to select the type of sort. When one is selected, an arrow up and down is displayed beside the Sort Sequence number on the Selected Fields window.
Display Tab
The Display tab is used to control the display of records in the Extract.
The Display checkbox is used to control the display of the field in the Extract. If not checked, the resulting field will not be displayed in the Extract. A common use of this checkbox would be to select only Active employees from the database, but not to display the field Active in the Extract.
The Label displays the name of the currently selected field. This can be changed to suit your requirements. The name entered is displayed on the report.